﻿CREATE TABLE [dbo].[Backup] (
    [BackupMethod]      VARCHAR (50)     NULL,
    [ConfigurationOnly] BIT              NULL,
    [Directory]         VARCHAR (200)    NULL,
    [DirectoryName]     VARCHAR (200)    NULL,
    [EndTime]           DATETIME         NULL,
    [ErrorCount]        INT              NULL,
    [FailureMessage]    VARCHAR (200)    NULL,
    [isFailure]         BIT              NULL,
    [Name]              VARCHAR (200)    NULL,
    [ParentId]          UNIQUEIDENTIFIER NULL,
    [RequestedBy]       VARCHAR (200)    NULL,
    [BackupID]          UNIQUEIDENTIFIER NOT NULL,
    [StartTime]         DATETIME         NULL,
    [TopComponent]      VARCHAR (200)    NULL,
    [TopComponentID]    UNIQUEIDENTIFIER NULL,
    [WarningCount]      INT              NULL,
    CONSTRAINT [PK_Backup] PRIMARY KEY CLUSTERED ([BackupID] ASC)
);

